Skip to main content

Google Cloud BigQuery data types

The following table shows the Google Cloud BigQuery data types that are supported when ingesting data from Google Cloud BigQuery and the default mapping to Qlik Compose data types.

For information on how to view the data type that is mapped in the data warehouse, see the section for the data warehouse database you are using.

Data type mappings
Google Cloud BigQuery data types Qlik Compose data types

DATE

Date

TIME

Time

TIMESTAMP

Datetime

INT64

BigInt

NUMERIC(p,s)

Decimal(p,s)

FLOAT64

Decimal(38,12)

STRING

Varchar

BOOLEAN

Varchar(5) - True or False

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!